SUPPORT / SAMPLES & SAS NOTES
Problem Note 55674: Campaigns fail with deadlock errors when you publish user-defined fields in the Communication node to the Reporting Common Data Model
 |  |  |  |  |
When you execute SAS® Customer Intelligence campaigns, the publish process might fail intermittently with the following error:
ERROR: Teradata insert: Transaction ABORTed due to deadlock. SQL statement was: USING ("COMMUNICATION_SK" DECIMAL(10),"CHAR_UDF_NM" VARCHAR (60),"CHAR_UDF_VAL" VARCHAR (500),"CHAR_EXT_COLUMN_NM"
VARCHAR (30),"PROCESSED_DTTM" CHAR (26))INSERT INTO cdm."CI_COMMUNICATION_CHAR_UDF" ("COMMUNICATION_SK","CHAR_UDF_NM","CHAR_UDF_VAL","CHAR_EXT_COLUMN_NM","PROCESSED_DTTM") VALUES
(:"COMMUNICATION_SK",:"CHAR_UDF_NM",:"CHAR_UDF_VAL",:"CHAR_EXT_COLUMN_NM",:"PROCESSED_DTTM"). Insert substitution values are not shown.
NOTE: Statements not processed because of errors noted above.
This problem occurs when you publish user-defined fields in the Communication node to the Reporting Common Data Model.
In this situation, the campaign often completes successfully if you re-execute it.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Processes | Microsoft® Windows® for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 5.41 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled HP-UX | 5.41 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.41 | 6.3 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.41 | 6.3 | 9.4 TS1M0 | |||
| Linux for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |||